<?php
@include('include/common.inc.php');
@include('logincleck.php');	
$mem_id = $_SESSION['mem_id'];
$cs = "select * from $TBL_KEEP,$TBL_HOUSE where $TBL_HOUSE.num=$TBL_KEEP.hou_num and $TBL_KEEP.mem_id ='$mem_id'  order by $TBL_KEEP.id desc";
$cur_page = (int)$_GET["p"];   //获取当前页
$url_param = preg_replace("/(p=[0-9]+)&/", "", $_SERVER['QUERY_STRING']);
$pages = new Pager($cs, $cur_page, 15, $url_param);
$page_string = $pages -> getPageString();   
$result = $pages -> getRsPerPage();
$count = mysql_num_rows($result);
while($rows = $db->fetch_array($result))
{
	$rows['ADDR']=FSubstr(str_replace("&nbsp;","",strip_tags($rows[address])),0,40);	
	$rows['hou_id']=$rows['id'];
	$row1[]=$rows;
}
@include('number.php');//验证码
$smarty->assign("row1",$row1);
$smarty->assign("page_string",$page_string);
$smarty->display('sc.html');
?>